在线等sql = "insert into 语句问题

来源:百度知道 编辑:UC知道 时间:2024/05/24 18:32:58
本人是新手不是很懂
sql = "insert into Group(Rid, Group_Name, Email, Mome) "
sql = sql & " values('" & Rid & "','" & Team & "','" & Mail & "','" & Remarks & "')"
Response.Write sql

其中Group是我的access表名 其中有4项
values里是我的数值
现在不知道是什么错误数值写不进 数据库
希望有高手帮我看下 怎么改 然后最好可以说明问题出在哪儿了
感谢
<%
dim Team , Mail , Remarks,Rid,sql
Rid="1"
Team = Trim(Request.form("Team")) '部门
Mail = Trim(Request.form("Mail")) '电子邮件
Remarks = Trim(Request.form("Remarks")) '备注
Response.Write Team
Response.Write Mail
Response.Write Remarks
sql = "insert into Group(Rid, Group_Name, Email, Mome) "
sql = sql & " values(" & Rid & ",'" & Team & "','" & Mail & "','" & Remarks & "')"
Response.end
conn.Ex

sql = "insert into Group(Rid, Group_Name, Email, Mome) "
sql = sql & " values(" & Rid & ",'" & Team & "','" & Mail & "','" & Remarks & "')"

改成这样。

sql = "insert into [Group](Rid, Group_Name, Email, Mome) "
sql = sql & " values(" & Rid & ",'" & Team & "','" & Mail & "','" & Remarks & "')"

改成这样。

group是保留字,用[]包含进来